package com.jdz.noise.dao;

import com.jdz.noise.entities.FlyRow;
import com.jdz.noise.entities.FlyStatus;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface FlyStatusDao {
    //获取所有得flystatus信息
    public List<FlyStatus> getAllFlyStatusInfo();
    //通过指控时速获取整个flyrow数据
    List<FlyStatus> getFlyRowByIndicatedAirspeed(@Param("indicated_airspeed") Double indicated_airspeed);
    @Insert("INSERT INTO acoustic.fly_status(id, sphere_id, indicated_airspeed, torque, rotor_speed, fuel_weight, barometric_height, static_temperature, desinfo) VALUES(#{data.id}, #{data.sphere_id}, #{data.indicated_airspeed}, #{data.torque}, #{data.rotor_speed}, #{data.fuel_weight}, #{data.barometric_height}, #{data.static_temperature}, #{data.desinfo})")
    //添加飞行数据
    Integer insertFlyStatus(@Param("data") FlyStatus data);
}
